﻿CREATE PROCEDURE [dbo].[Tournament_Members_SelectByLeagueIdTournamentName]
   @league_id uniqueidentifier,
   @tournament_name nvarchar (40)
AS
  SELECT [league_id],
         [tournament_name],
         [bowler_id]
    FROM [dbo].[Tournament_Members]
   WHERE [league_id] = @league_id
         AND [tournament_name] LIKE @tournament_name + '%'


